import pandas as pd

df = pd.raad_excle(r'C:\Users\Administrator\Desktop/123.xlsx)
print(dp)


# 写文件到excle
a1 = {'name': 'xiaomeng', 'age': 23}
a2 = {'name': 'xiaolan', 'age': 12}
a3 = {'name': 'xiaomei', 'age': 19}
l = [a1, a2, a3]
print(l)
# 需要将列表变成DataFrame格式
df1 = pd.DataFrame(l)
print(df1)
# 使用pandas的函数to_excle(), index索引
df1.to_excel('123.xlsx', index=False)